Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 38802 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 4901 |
| Duplicate rows (%) | 12.6% |
| Total size in memory | 6.2 MiB |
| Average record size in memory | 168.0 B |
Variable types
| Categorical | 9 |
|---|---|
| Numeric | 8 |
| Text | 3 |
| DateTime | 1 |
OrderCount has constant value "" | Constant |
Country_y has constant value "" | Constant |
| Dataset has 4901 (12.6%) duplicate rows | Duplicates |
Employee is highly overall correlated with State and 3 other fields | High correlation |
ListPrice is highly overall correlated with Sales and 4 other fields | High correlation |
Sales is highly overall correlated with ListPrice and 3 other fields | High correlation |
SaleswithStandard is highly overall correlated with ListPrice and 3 other fields | High correlation |
StandardCost is highly overall correlated with ListPrice and 4 other fields | High correlation |
State is highly overall correlated with Employee and 3 other fields | High correlation |
StateCD is highly overall correlated with Employee and 3 other fields | High correlation |
State_duplicated_0 is highly overall correlated with Employee and 3 other fields | High correlation |
UnitPrice is highly overall correlated with ListPrice and 4 other fields | High correlation |
productcategory is highly overall correlated with ListPrice and 3 other fields | High correlation |
productsubcategory is highly overall correlated with productcategory | High correlation |
saleterritory is highly overall correlated with Employee and 3 other fields | High correlation |
Reproduction
| Analysis started | 2024-01-10 00:21:51.021898 |
|---|---|
| Analysis finished | 2024-01-10 00:21:57.455040 |
| Duration | 6.43 seconds |
| Software version | ydata-profiling vv4.6.4 |
| Download configuration | config.json |
productcategory
Categorical
HIGH CORRELATION 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 303.3 KiB |
| Bikes | |
|---|---|
| Components | |
| Clothing | |
| Accessories |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 7.5731406 |
| Min length | 5 |
Characters and Unicode
| Total characters | 293853 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Clothing |
|---|---|
| 2nd row | Clothing |
| 3rd row | Components |
| 4th row | Clothing |
| 5th row | Clothing |
Common Values
| Value | Count | Frequency (%) |
| Bikes | 16453 | |
| Components | 11904 | |
| Clothing | 7449 | |
| Accessories | 2996 | 7.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| bikes | 16453 | |
| components | 11904 | |
| clothing | 7449 | |
| accessories | 2996 | 7.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 37345 | |
| e | 34349 | |
| o | 34253 | |
| n | 31257 | |
| i | 26898 | |
| C | 19353 | |
| t | 19353 | |
| B | 16453 | 5.6% |
| k | 16453 | 5.6% |
| p | 11904 | 4.1% |
| Other values (7) | 46235 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 255051 | |
| Uppercase Letter | 38802 | 13.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 37345 | |
| e | 34349 | |
| o | 34253 | |
| n | 31257 | |
| i | 26898 | |
| t | 19353 | |
| k | 16453 | |
| p | 11904 | 4.7% |
| m | 11904 | 4.7% |
| l | 7449 | 2.9% |
| Other values (4) | 23886 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 19353 | |
| B | 16453 | |
| A | 2996 | 7.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 293853 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 37345 | |
| e | 34349 | |
| o | 34253 | |
| n | 31257 | |
| i | 26898 | |
| C | 19353 | |
| t | 19353 | |
| B | 16453 | 5.6% |
| k | 16453 | 5.6% |
| p | 11904 | 4.1% |
| Other values (7) | 46235 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 293853 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 37345 | |
| e | 34349 | |
| o | 34253 | |
| n | 31257 | |
| i | 26898 | |
| C | 19353 | |
| t | 19353 | |
| B | 16453 | 5.6% |
| k | 16453 | 5.6% |
| p | 11904 | 4.1% |
| Other values (7) | 46235 |
productsubcategory
Categorical
HIGH CORRELATION 
| Distinct | 33 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 303.3 KiB |
| Road Bikes | |
|---|---|
| Mountain Bikes | |
| Road Frames | |
| Mountain Frames | |
| Jerseys | |
| Other values (28) |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 10.086284 |
| Min length | 4 |
Characters and Unicode
| Total characters | 391368 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Caps |
|---|---|
| 2nd row | Caps |
| 3rd row | Mountain Frames |
| 4th row | Jerseys |
| 5th row | Jerseys |
Common Values
| Value | Count | Frequency (%) |
| Road Bikes | 9224 | |
| Mountain Bikes | 5137 | |
| Road Frames | 3145 | 8.1% |
| Mountain Frames | 3032 | 7.8% |
| Jerseys | 2279 | 5.9% |
| Touring Bikes | 2092 | 5.4% |
| Helmets | 1723 | 4.4% |
| Wheels | 1327 | 3.4% |
| Gloves | 1271 | 3.3% |
| Handlebars | 984 | 2.5% |
| Other values (23) | 8588 |
Length
| Value | Count | Frequency (%) |
| bikes | 16453 | |
| road | 12369 | |
| mountain | 8169 | |
| frames | 6874 | |
| touring | 2789 | 4.4% |
| jerseys | 2279 | 3.6% |
| helmets | 1723 | 2.7% |
| wheels | 1327 | 2.1% |
| gloves | 1271 | 2.0% |
| handlebars | 984 | 1.6% |
| Other values (28) | 9106 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 42251 | 10.8% |
| e | 40814 | 10.4% |
| a | 34047 | 8.7% |
| i | 29358 | 7.5% |
| o | 27762 | 7.1% |
| 24542 | 6.3% | |
| n | 21165 | 5.4% |
| k | 18643 | 4.8% |
| B | 18003 | 4.6% |
| r | 16008 | 4.1% |
| Other values (27) | 118775 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 302794 | |
| Uppercase Letter | 63535 | 16.2% |
| Space Separator | 24542 | 6.3% |
| Dash Punctuation | 497 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 42251 | |
| e | 40814 | |
| a | 34047 | |
| i | 29358 | |
| o | 27762 | |
| n | 21165 | |
| k | 18643 | |
| r | 16008 | 5.3% |
| d | 15931 | 5.3% |
| t | 14053 | 4.6% |
| Other values (10) | 42762 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 18003 | |
| R | 12602 | |
| M | 8169 | |
| F | 7016 | 11.0% |
| T | 3581 | 5.6% |
| H | 3067 | 4.8% |
| S | 2534 | 4.0% |
| J | 2279 | 3.6% |
| C | 1563 | 2.5% |
| W | 1327 | 2.1% |
| Other values (5) | 3394 | 5.3% |
Space Separator
| Value | Count | Frequency (%) |
| 24542 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 497 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 366329 | |
| Common | 25039 | 6.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 42251 | |
| e | 40814 | 11.1% |
| a | 34047 | 9.3% |
| i | 29358 | 8.0% |
| o | 27762 | 7.6% |
| n | 21165 | 5.8% |
| k | 18643 | 5.1% |
| B | 18003 | 4.9% |
| r | 16008 | 4.4% |
| d | 15931 | 4.3% |
| Other values (25) | 102347 |
Common
| Value | Count | Frequency (%) |
| 24542 | ||
| - | 497 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 391368 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 42251 | 10.8% |
| e | 40814 | 10.4% |
| a | 34047 | 8.7% |
| i | 29358 | 7.5% |
| o | 27762 | 7.1% |
| 24542 | 6.3% | |
| n | 21165 | 5.4% |
| k | 18643 | 4.8% |
| B | 18003 | 4.6% |
| r | 16008 | 4.1% |
| Other values (27) | 118775 |
saleterritory
Categorical
HIGH CORRELATION 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 303.3 KiB |
| Southwest | |
|---|---|
| Northwest | |
| Southeast | |
| Central | |
| Northeast |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.7004278 |
| Min length | 7 |
Characters and Unicode
| Total characters | 337594 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Northwest |
|---|---|
| 2nd row | Northwest |
| 3rd row | Northwest |
| 4th row | Northwest |
| 5th row | Northwest |
Common Values
| Value | Count | Frequency (%) |
| Southwest | 13379 | |
| Northwest | 7865 | |
| Southeast | 5937 | |
| Central | 5812 | |
| Northeast | 5809 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| southwest | 13379 | |
| northwest | 7865 | |
| southeast | 5937 | |
| central | 5812 | |
| northeast | 5809 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 71792 | |
| e | 38802 | |
| o | 32990 | |
| h | 32990 | |
| s | 32990 | |
| w | 21244 | 6.3% |
| r | 19486 | 5.8% |
| S | 19316 | 5.7% |
| u | 19316 | 5.7% |
| a | 17558 | 5.2% |
| Other values (4) | 31110 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 298792 | |
| Uppercase Letter | 38802 | 11.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 71792 | |
| e | 38802 | |
| o | 32990 | |
| h | 32990 | |
| s | 32990 | |
| w | 21244 | 7.1% |
| r | 19486 | 6.5% |
| u | 19316 | 6.5% |
| a | 17558 | 5.9% |
| n | 5812 | 1.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 19316 | |
| N | 13674 | |
| C | 5812 | 15.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 337594 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 71792 | |
| e | 38802 | |
| o | 32990 | |
| h | 32990 | |
| s | 32990 | |
| w | 21244 | 6.3% |
| r | 19486 | 5.8% |
| S | 19316 | 5.7% |
| u | 19316 | 5.7% |
| a | 17558 | 5.2% |
| Other values (4) | 31110 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 337594 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 71792 | |
| e | 38802 | |
| o | 32990 | |
| h | 32990 | |
| s | 32990 | |
| w | 21244 | 6.3% |
| r | 19486 | 5.8% |
| S | 19316 | 5.7% |
| u | 19316 | 5.7% |
| a | 17558 | 5.2% |
| Other values (4) | 31110 |
zip
Real number (ℝ)
| Distinct | 302 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 66052.637 |
| Minimum | 2062 |
|---|---|
| Maximum | 99337 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 303.3 KiB |
Quantile statistics
| Minimum | 2062 |
|---|---|
| 5-th percentile | 6460 |
| Q1 | 39501 |
| median | 77840 |
| Q3 | 91801 |
| 95-th percentile | 98225 |
| Maximum | 99337 |
| Range | 97275 |
| Interquartile range (IQR) | 52300 |
Descriptive statistics
| Standard deviation | 30207.247 |
|---|---|
| Coefficient of variation (CV) | 0.45732083 |
| Kurtosis | -0.84422923 |
| Mean | 66052.637 |
| Median Absolute Deviation (MAD) | 19382 |
| Skewness | -0.69798759 |
| Sum | 2.5629744 × 109 |
| Variance | 9.1247775 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 98104 | 817 | 2.1% |
| 75040 | 712 | 1.8% |
| 77003 | 677 | 1.7% |
| 85004 | 670 | 1.7% |
| 75061 | 654 | 1.7% |
| 33127 | 648 | 1.7% |
| 63103 | 601 | 1.5% |
| 3064 | 595 | 1.5% |
| 38103 | 592 | 1.5% |
| 78204 | 521 | 1.3% |
| Other values (292) | 32315 |
| Value | Count | Frequency (%) |
| 2062 | 21 | 0.1% |
| 2093 | 21 | 0.1% |
| 2184 | 31 | 0.1% |
| 2368 | 61 | 0.2% |
| 2889 | 17 | < 0.1% |
| 2895 | 1 | < 0.1% |
| 3064 | 595 | |
| 3106 | 10 | < 0.1% |
| 3276 | 279 | |
| 3865 | 380 |
| Value | Count | Frequency (%) |
| 99337 | 3 | < 0.1% |
| 99202 | 165 | |
| 98926 | 286 | |
| 98801 | 11 | < 0.1% |
| 98671 | 11 | < 0.1% |
| 98632 | 228 | |
| 98626 | 166 | |
| 98584 | 10 | < 0.1% |
| 98532 | 65 | 0.2% |
| 98503 | 358 |
State
Categorical
HIGH CORRELATION 
| Distinct | 35 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 303.3 KiB |
| California | |
|---|---|
| Texas | |
| Washington | |
| Florida | 1851 |
| Colorado | 1673 |
| Other values (30) |
Length
| Max length | 14 |
|---|---|
| Median length | 12 |
| Mean length | 8.2941086 |
| Min length | 4 |
Characters and Unicode
| Total characters | 321828 |
|---|---|
| Distinct characters | 43 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Wyoming |
|---|---|
| 2nd row | Washington |
| 3rd row | Washington |
| 4th row | Wyoming |
| 5th row | Washington |
Common Values
| Value | Count | Frequency (%) |
| California | 6920 | |
| Texas | 4785 | 12.3% |
| Washington | 4574 | 11.8% |
| Florida | 1851 | 4.8% |
| Colorado | 1673 | 4.3% |
| Michigan | 1389 | 3.6% |
| New York | 1370 | 3.5% |
| Missouri | 1284 | 3.3% |
| New Hampshire | 1264 | 3.3% |
| Tennessee | 1212 | 3.1% |
| Other values (25) | 12480 |
Length
| Value | Count | Frequency (%) |
| california | 6920 | |
| texas | 4785 | 11.1% |
| washington | 4574 | 10.6% |
| new | 3157 | 7.3% |
| florida | 1851 | 4.3% |
| colorado | 1673 | 3.9% |
| michigan | 1389 | 3.2% |
| york | 1370 | 3.2% |
| missouri | 1284 | 3.0% |
| hampshire | 1264 | 2.9% |
| Other values (28) | 14785 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 39582 | |
| i | 38720 | |
| o | 30523 | 9.5% |
| n | 30512 | 9.5% |
| r | 19724 | 6.1% |
| e | 19388 | 6.0% |
| s | 19264 | 6.0% |
| l | 12399 | 3.9% |
| C | 10462 | 3.3% |
| h | 10358 | 3.2% |
| Other values (33) | 90896 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 274526 | |
| Uppercase Letter | 43052 | 13.4% |
| Space Separator | 4250 | 1.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 39582 | |
| i | 38720 | |
| o | 30523 | |
| n | 30512 | |
| r | 19724 | |
| e | 19388 | |
| s | 19264 | |
| l | 12399 | 4.5% |
| h | 10358 | 3.8% |
| t | 9531 | 3.5% |
| Other values (14) | 44525 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 10462 | |
| T | 5997 | |
| W | 5331 | |
| N | 4619 | |
| M | 4603 | |
| O | 1947 | 4.5% |
| F | 1851 | 4.3% |
| I | 1563 | 3.6% |
| Y | 1370 | 3.2% |
| H | 1264 | 2.9% |
| Other values (8) | 4045 | 9.4% |
Space Separator
| Value | Count | Frequency (%) |
| 4250 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 317578 | |
| Common | 4250 | 1.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 39582 | |
| i | 38720 | |
| o | 30523 | 9.6% |
| n | 30512 | 9.6% |
| r | 19724 | 6.2% |
| e | 19388 | 6.1% |
| s | 19264 | 6.1% |
| l | 12399 | 3.9% |
| C | 10462 | 3.3% |
| h | 10358 | 3.3% |
| Other values (32) | 86646 |
Common
| Value | Count | Frequency (%) |
| 4250 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 321828 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 39582 | |
| i | 38720 | |
| o | 30523 | 9.5% |
| n | 30512 | 9.5% |
| r | 19724 | 6.1% |
| e | 19388 | 6.0% |
| s | 19264 | 6.0% |
| l | 12399 | 3.9% |
| C | 10462 | 3.3% |
| h | 10358 | 3.2% |
| Other values (33) | 90896 |
Customer
Text
| Distinct | 390 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 303.3 KiB |
Length
| Max length | 29 |
|---|---|
| Median length | 19 |
| Mean length | 13.037575 |
| Min length | 7 |
Characters and Unicode
| Total characters | 505884 |
|---|---|
| Distinct characters | 55 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 19 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | François Ferrier |
|---|---|
| 2nd row | Richard Bready |
| 3rd row | Carolyn Farino |
| 4th row | François Ferrier |
| 5th row | Richard Bready |
| Value | Count | Frequency (%) |
| john | 1354 | 1.7% |
| robert | 1064 | 1.4% |
| liu | 960 | 1.2% |
| richard | 847 | 1.1% |
| michael | 838 | 1.1% |
| mike | 746 | 1.0% |
| kevin | 573 | 0.7% |
| andrew | 569 | 0.7% |
| allen | 555 | 0.7% |
| mary | 555 | 0.7% |
| Other values (621) | 69836 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 49123 | 9.7% |
| e | 46588 | 9.2% |
| n | 40889 | 8.1% |
| 39095 | 7.7% | |
| r | 37021 | 7.3% |
| i | 32248 | 6.4% |
| o | 25244 | 5.0% |
| l | 21539 | 4.3% |
| t | 18015 | 3.6% |
| s | 16865 | 3.3% |
| Other values (45) | 179257 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 385876 | |
| Uppercase Letter | 80051 | 15.8% |
| Space Separator | 39095 | 7.7% |
| Dash Punctuation | 696 | 0.1% |
| Other Punctuation | 166 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 49123 | |
| e | 46588 | |
| n | 40889 | |
| r | 37021 | |
| i | 32248 | 8.4% |
| o | 25244 | 6.5% |
| l | 21539 | 5.6% |
| t | 18015 | 4.7% |
| s | 16865 | 4.4% |
| h | 14798 | 3.8% |
| Other values (17) | 83546 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 7996 | |
| M | 7193 | 9.0% |
| J | 6995 | 8.7% |
| D | 6166 | 7.7% |
| A | 6161 | 7.7% |
| B | 6110 | 7.6% |
| K | 5772 | 7.2% |
| L | 4734 | 5.9% |
| S | 4639 | 5.8% |
| H | 4476 | 5.6% |
| Other values (14) | 19809 |
Other Punctuation
| Value | Count | Frequency (%) |
| ¡ | 110 | |
| . | 56 |
Space Separator
| Value | Count | Frequency (%) |
| 39095 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 696 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 465927 | |
| Common | 39957 | 7.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 49123 | 10.5% |
| e | 46588 | 10.0% |
| n | 40889 | 8.8% |
| r | 37021 | 7.9% |
| i | 32248 | 6.9% |
| o | 25244 | 5.4% |
| l | 21539 | 4.6% |
| t | 18015 | 3.9% |
| s | 16865 | 3.6% |
| h | 14798 | 3.2% |
| Other values (41) | 163597 |
Common
| Value | Count | Frequency (%) |
| 39095 | ||
| - | 696 | 1.7% |
| ¡ | 110 | 0.3% |
| . | 56 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 505484 | |
| None | 400 | 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 49123 | 9.7% |
| e | 46588 | 9.2% |
| n | 40889 | 8.1% |
| 39095 | 7.7% | |
| r | 37021 | 7.3% |
| i | 32248 | 6.4% |
| o | 25244 | 5.0% |
| l | 21539 | 4.3% |
| t | 18015 | 3.6% |
| s | 16865 | 3.3% |
| Other values (43) | 178857 |
None
| Value | Count | Frequency (%) |
| ç | 290 | |
| ¡ | 110 | 27.5% |
Employee
Categorical
HIGH CORRELATION 
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 303.3 KiB |
| Jillian Carson | |
|---|---|
| Linda Mitchell | |
| Michael Blythe | |
| Tsvi Reiter | |
| Shu Ito | |
| Other values (4) |
Length
| Max length | 19 |
|---|---|
| Median length | 14 |
| Mean length | 13.107881 |
| Min length | 7 |
Characters and Unicode
| Total characters | 508612 |
|---|---|
| Distinct characters | 35 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | David Campbell |
|---|---|
| 2nd row | David Campbell |
| 3rd row | David Campbell |
| 4th row | David Campbell |
| 5th row | David Campbell |
Common Values
| Value | Count | Frequency (%) |
| Jillian Carson | 7825 | |
| Linda Mitchell | 7107 | |
| Michael Blythe | 7069 | |
| Tsvi Reiter | 5417 | |
| Shu Ito | 4545 | |
| David Campbell | 2247 | 5.8% |
| Pamela Ansman-Wolfe | 2064 | 5.3% |
| Tete Mensa-Annan | 1886 | 4.9% |
| Stephen Jiang | 642 | 1.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| jillian | 7825 | |
| carson | 7825 | |
| linda | 7107 | |
| mitchell | 7107 | |
| michael | 7069 | |
| blythe | 7069 | |
| tsvi | 5417 | 7.0% |
| reiter | 5417 | 7.0% |
| ito | 4545 | 5.9% |
| shu | 4545 | 5.9% |
| Other values (8) | 13678 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 52624 | 10.3% |
| i | 50656 | 10.0% |
| e | 45396 | 8.9% |
| a | 44926 | 8.8% |
| 38802 | 7.6% | |
| n | 35713 | 7.0% |
| t | 26666 | 5.2% |
| h | 26432 | 5.2% |
| s | 17192 | 3.4% |
| M | 16062 | 3.2% |
| Other values (25) | 154143 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 384306 | |
| Uppercase Letter | 81554 | 16.0% |
| Space Separator | 38802 | 7.6% |
| Dash Punctuation | 3950 | 0.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 52624 | |
| i | 50656 | |
| e | 45396 | |
| a | 44926 | |
| n | 35713 | |
| t | 26666 | |
| h | 26432 | |
| s | 17192 | 4.5% |
| o | 14434 | 3.8% |
| c | 14176 | 3.7% |
| Other values (10) | 56091 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 16062 | |
| C | 10072 | |
| J | 8467 | |
| T | 7303 | |
| L | 7107 | |
| B | 7069 | |
| R | 5417 | 6.6% |
| S | 5187 | 6.4% |
| I | 4545 | 5.6% |
| A | 3950 | 4.8% |
| Other values (3) | 6375 | 7.8% |
Space Separator
| Value | Count | Frequency (%) |
| 38802 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3950 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 465860 | |
| Common | 42752 | 8.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 52624 | 11.3% |
| i | 50656 | 10.9% |
| e | 45396 | 9.7% |
| a | 44926 | 9.6% |
| n | 35713 | 7.7% |
| t | 26666 | 5.7% |
| h | 26432 | 5.7% |
| s | 17192 | 3.7% |
| M | 16062 | 3.4% |
| o | 14434 | 3.1% |
| Other values (23) | 135759 |
Common
| Value | Count | Frequency (%) |
| 38802 | ||
| - | 3950 | 9.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 508612 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 52624 | 10.3% |
| i | 50656 | 10.0% |
| e | 45396 | 8.9% |
| a | 44926 | 8.8% |
| 38802 | 7.6% | |
| n | 35713 | 7.0% |
| t | 26666 | 5.2% |
| h | 26432 | 5.2% |
| s | 17192 | 3.4% |
| M | 16062 | 3.2% |
| Other values (25) | 154143 |
OrderCount
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 303.3 KiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 38802 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 38802 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 38802 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 38802 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 38802 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 38802 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 38802 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 38802 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 38802 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 38802 |
OrderDate
Date
| Distinct | 36 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 303.3 KiB |
| Minimum | 2011-05-31 00:00:00 |
|---|---|
| Maximum | 2014-05-01 00:00:00 |
StandardCost
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 90 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 474.68394 |
| Minimum | 0.8565 |
|---|---|
| Maximum | 2171.2942 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 303.3 KiB |
Quantile statistics
| Minimum | 0.8565 |
|---|---|
| 5-th percentile | 8.2459 |
| Q1 | 35.9596 |
| median | 294.5797 |
| Q3 | 713.0798 |
| 95-th percentile | 1554.9479 |
| Maximum | 2171.2942 |
| Range | 2170.4377 |
| Interquartile range (IQR) | 677.1202 |
Descriptive statistics
| Standard deviation | 546.40695 |
|---|---|
| Coefficient of variation (CV) | 1.1510963 |
| Kurtosis | 0.74941848 |
| Mean | 474.68394 |
| Median Absolute Deviation (MAD) | 269.8338 |
| Skewness | 1.2822201 |
| Sum | 18418686 |
| Variance | 298560.56 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 486.7066 | 3936 | 10.1% |
| 13.0863 | 1723 | 4.4% |
| 38.4923 | 1654 | 4.3% |
| 713.0798 | 1305 | 3.4% |
| 1554.9479 | 1134 | 2.9% |
| 1251.9813 | 1048 | 2.7% |
| 1265.6195 | 960 | 2.5% |
| 187.1571 | 955 | 2.5% |
| 461.4448 | 884 | 2.3% |
| 360.9428 | 829 | 2.1% |
| Other values (80) | 24374 |
| Value | Count | Frequency (%) |
| 0.8565 | 78 | 0.2% |
| 1.8663 | 228 | 0.6% |
| 2.9733 | 220 | 0.6% |
| 3.3623 | 431 | |
| 3.3963 | 187 | 0.5% |
| 6.9223 | 759 | |
| 8.2459 | 173 | 0.4% |
| 8.9866 | 127 | 0.3% |
| 9.1593 | 659 | |
| 10.3125 | 169 | 0.4% |
| Value | Count | Frequency (%) |
| 2171.2942 | 428 | 1.1% |
| 1912.1544 | 593 | |
| 1898.0944 | 604 | |
| 1554.9479 | 1134 | |
| 1518.7864 | 427 | 1.1% |
| 1481.9379 | 803 | |
| 1265.6195 | 960 | |
| 1251.9813 | 1048 | |
| 1082.51 | 665 | |
| 884.7083 | 687 |
UnitPrice
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 220 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 464.63949 |
| Minimum | 1.374 |
|---|---|
| Maximum | 2146.962 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 303.3 KiB |
Quantile statistics
| Minimum | 1.374 |
|---|---|
| 5-th percentile | 11.994 |
| Q1 | 36.447 |
| median | 323.994 |
| Q3 | 672.294 |
| 95-th percentile | 1466.01 |
| Maximum | 2146.962 |
| Range | 2145.588 |
| Interquartile range (IQR) | 635.847 |
Descriptive statistics
| Standard deviation | 535.43009 |
|---|---|
| Coefficient of variation (CV) | 1.152356 |
| Kurtosis | 1.2506734 |
| Mean | 464.63949 |
| Median Absolute Deviation (MAD) | 291.6 |
| Skewness | 1.3998869 |
| Sum | 18028941 |
| Variance | 286685.38 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 469.794 | 2130 | 5.5% |
| 419.4589 | 1696 | 4.4% |
| 28.8404 | 1136 | 2.9% |
| 20.1865 | 1057 | 2.7% |
| 323.994 | 1056 | 2.7% |
| 1466.01 | 968 | 2.5% |
| 202.332 | 798 | 2.1% |
| 183.9382 | 723 | 1.9% |
| 874.794 | 686 | 1.8% |
| 1430.442 | 684 | 1.8% |
| Other values (210) | 27868 |
| Value | Count | Frequency (%) |
| 1.374 | 78 | 0.2% |
| 2.495 | 1 | < 0.1% |
| 2.7445 | 7 | < 0.1% |
| 2.8942 | 15 | < 0.1% |
| 2.994 | 205 | |
| 3.975 | 1 | < 0.1% |
| 4.3221 | 1 | < 0.1% |
| 4.3725 | 8 | < 0.1% |
| 4.495 | 3 | < 0.1% |
| 4.611 | 20 | 0.1% |
| Value | Count | Frequency (%) |
| 2146.962 | 428 | |
| 2039.994 | 537 | |
| 2024.994 | 544 | |
| 1971.9942 | 3 | < 0.1% |
| 1957.4942 | 5 | < 0.1% |
| 1466.01 | 968 | |
| 1430.442 | 684 | |
| 1417.143 | 4 | < 0.1% |
| 1391.994 | 377 | 1.0% |
| 1382.7606 | 9 | < 0.1% |
ListPrice
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 103 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 785.08191 |
| Minimum | 2.29 |
|---|---|
| Maximum | 3578.27 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 303.3 KiB |
Quantile statistics
| Minimum | 2.29 |
|---|---|
| 5-th percentile | 19.99 |
| Q1 | 60.745 |
| median | 539.99 |
| Q3 | 1120.49 |
| 95-th percentile | 2443.35 |
| Maximum | 3578.27 |
| Range | 3575.98 |
| Interquartile range (IQR) | 1059.745 |
Descriptive statistics
| Standard deviation | 904.6905 |
|---|---|
| Coefficient of variation (CV) | 1.1523517 |
| Kurtosis | 1.1801335 |
| Mean | 785.08191 |
| Median Absolute Deviation (MAD) | 486 |
| Skewness | 1.3904479 |
| Sum | 30462748 |
| Variance | 818464.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 782.99 | 2238 | 5.8% |
| 699.0982 | 1698 | 4.4% |
| 48.0673 | 1172 | 3.0% |
| 33.6442 | 1164 | 3.0% |
| 539.99 | 1061 | 2.7% |
| 2443.35 | 972 | 2.5% |
| 742.35 | 884 | 2.3% |
| 2384.07 | 803 | 2.1% |
| 337.22 | 802 | 2.1% |
| 306.5636 | 724 | 1.9% |
| Other values (93) | 27284 |
| Value | Count | Frequency (%) |
| 2.29 | 78 | 0.2% |
| 4.99 | 228 | 0.6% |
| 7.95 | 220 | 0.6% |
| 8.6442 | 518 | |
| 8.99 | 672 | |
| 9.5 | 187 | 0.5% |
| 19.99 | 173 | 0.4% |
| 20.24 | 127 | 0.3% |
| 23.5481 | 312 | |
| 24.49 | 347 |
| Value | Count | Frequency (%) |
| 3578.27 | 428 | |
| 3399.99 | 593 | |
| 3374.99 | 604 | |
| 2443.35 | 972 | |
| 2384.07 | 803 | |
| 2319.99 | 387 | 1.0% |
| 2294.99 | 461 | |
| 2181.5625 | 589 | |
| 2071.4196 | 573 | |
| 2049.0982 | 587 |
SaleswithStandard
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1076 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1418.4338 |
| Minimum | 0.8565 |
|---|---|
| Maximum | 38530.385 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 303.3 KiB |
Quantile statistics
| Minimum | 0.8565 |
|---|---|
| 5-th percentile | 20.3778 |
| Q1 | 107.8656 |
| median | 486.7066 |
| Q3 | 1737.2684 |
| 95-th percentile | 6075.1456 |
| Maximum | 38530.385 |
| Range | 38529.529 |
| Interquartile range (IQR) | 1629.4028 |
Descriptive statistics
| Standard deviation | 2273.1128 |
|---|---|
| Coefficient of variation (CV) | 1.6025512 |
| Kurtosis | 17.386995 |
| Mean | 1418.4338 |
| Median Absolute Deviation (MAD) | 447.4477 |
| Skewness | 3.3513288 |
| Sum | 55038068 |
| Variance | 5167041.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 486.7066 | 1092 | 2.8% |
| 973.4132 | 988 | 2.5% |
| 1460.1198 | 696 | 1.8% |
| 1946.8264 | 417 | 1.1% |
| 187.1571 | 338 | 0.9% |
| 461.4448 | 320 | 0.8% |
| 26.1726 | 314 | 0.8% |
| 713.0798 | 310 | 0.8% |
| 76.9846 | 305 | 0.8% |
| 1426.1596 | 298 | 0.8% |
| Other values (1066) | 33724 |
| Value | Count | Frequency (%) |
| 0.8565 | 15 | |
| 1.713 | 11 | < 0.1% |
| 1.8663 | 20 | |
| 2.5695 | 6 | < 0.1% |
| 2.9733 | 26 | |
| 3.3623 | 34 | |
| 3.3963 | 13 | < 0.1% |
| 3.426 | 9 | < 0.1% |
| 3.7326 | 22 | |
| 4.2825 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 38530.3854 | 1 | |
| 32475.3 | 1 | |
| 31120.6959 | 1 | |
| 27062.75 | 1 | |
| 26770.1616 | 1 | |
| 26674.8822 | 1 | |
| 25192.9443 | 1 | |
| 24675.2272 | 1 | |
| 23711.0064 | 2 | |
| 22945.8528 | 2 |
NetSales
Real number (ℝ)
| Distinct | 1373 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -36.982001 |
| Minimum | -14846.244 |
|---|---|
| Maximum | 1278.396 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 19014 |
| Negative (%) | 49.0% |
| Memory size | 303.3 KiB |
Quantile statistics
| Minimum | -14846.244 |
|---|---|
| 5-th percentile | -336.2385 |
| Q1 | -57.9114 |
| median | 0.6023 |
| Q3 | 41.5086 |
| 95-th percentile | 250.0254 |
| Maximum | 1278.396 |
| Range | 16124.64 |
| Interquartile range (IQR) | 99.42 |
Descriptive statistics
| Standard deviation | 406.64194 |
|---|---|
| Coefficient of variation (CV) | -10.995672 |
| Kurtosis | 298.05816 |
| Mean | -36.982001 |
| Median Absolute Deviation (MAD) | 49.1085 |
| Skewness | -13.524238 |
| Sum | -1434975.6 |
| Variance | 165357.67 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -67.2477 | 629 | 1.6% |
| -134.4954 | 506 | 1.3% |
| -33.8252 | 473 | 1.2% |
| -16.9126 | 455 | 1.2% |
| -50.7378 | 422 | 1.1% |
| -67.6504 | 274 | 0.7% |
| -201.7431 | 263 | 0.7% |
| -9.9143 | 261 | 0.7% |
| -16.0348 | 249 | 0.6% |
| -19.3038 | 244 | 0.6% |
| Other values (1363) | 35026 |
| Value | Count | Frequency (%) |
| -14846.24378 | 1 | < 0.1% |
| -13496.58525 | 1 | < 0.1% |
| -12236.90423 | 1 | < 0.1% |
| -12146.92673 | 1 | < 0.1% |
| -11504.568 | 1 | < 0.1% |
| -10797.2682 | 3 | |
| -10636.7664 | 1 | < 0.1% |
| -9511.935 | 1 | < 0.1% |
| -9447.609675 | 2 | |
| -8157.93615 | 3 |
| Value | Count | Frequency (%) |
| 1278.396 | 4 | < 0.1% |
| 1268.996 | 4 | < 0.1% |
| 1263.745 | 5 | < 0.1% |
| 1250.127 | 6 | |
| 1150.5564 | 3 | < 0.1% |
| 1142.0964 | 10 | |
| 1137.3705 | 10 | |
| 1125.1143 | 9 | |
| 1022.7168 | 11 | |
| 1015.1968 | 14 |
OrderQuantity
Real number (ℝ)
| Distinct | 41 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4209577 |
| Minimum | 1 |
|---|---|
| Maximum | 44 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 303.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 9 |
| Maximum | 44 |
| Range | 43 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.9568605 |
|---|---|
| Coefficient of variation (CV) | 0.86433706 |
| Kurtosis | 17.887214 |
| Mean | 3.4209577 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 3.1322146 |
| Sum | 132740 |
| Variance | 8.7430241 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 9469 | |
| 2 | 9234 | |
| 3 | 6532 | |
| 4 | 4773 | |
| 5 | 2769 | 7.1% |
| 6 | 2033 | 5.2% |
| 7 | 1047 | 2.7% |
| 8 | 872 | 2.2% |
| 9 | 513 | 1.3% |
| 10 | 437 | 1.1% |
| Other values (31) | 1123 | 2.9% |
| Value | Count | Frequency (%) |
| 1 | 9469 | |
| 2 | 9234 | |
| 3 | 6532 | |
| 4 | 4773 | |
| 5 | 2769 | 7.1% |
| 6 | 2033 | 5.2% |
| 7 | 1047 | 2.7% |
| 8 | 872 | 2.2% |
| 9 | 513 | 1.3% |
| 10 | 437 | 1.1% |
| Value | Count | Frequency (%) |
| 44 | 1 | < 0.1% |
| 41 | 1 | < 0.1% |
| 40 | 2 | < 0.1% |
| 39 | 1 | < 0.1% |
| 38 | 1 | < 0.1% |
| 36 | 1 | < 0.1% |
| 35 | 2 | < 0.1% |
| 34 | 3 | |
| 33 | 6 | |
| 32 | 5 |
Sales
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1297 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1381.4518 |
| Minimum | 1.374 |
|---|---|
| Maximum | 27893.619 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 303.3 KiB |
Quantile statistics
| Minimum | 1.374 |
|---|---|
| 5-th percentile | 25.9325 |
| Q1 | 131.976 |
| median | 475.29 |
| Q3 | 1622.2635 |
| 95-th percentile | 5864.04 |
| Maximum | 27893.619 |
| Range | 27892.245 |
| Interquartile range (IQR) | 1490.2875 |
Descriptive statistics
| Standard deviation | 2198.0183 |
|---|---|
| Coefficient of variation (CV) | 1.591093 |
| Kurtosis | 15.496543 |
| Mean | 1381.4518 |
| Median Absolute Deviation (MAD) | 418.7744 |
| Skewness | 3.3061144 |
| Sum | 53603093 |
| Variance | 4831284.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 419.4589 | 629 | 1.6% |
| 838.9178 | 506 | 1.3% |
| 939.588 | 473 | 1.2% |
| 469.794 | 455 | 1.2% |
| 1409.382 | 422 | 1.1% |
| 323.994 | 322 | 0.8% |
| 183.9382 | 286 | 0.7% |
| 647.988 | 283 | 0.7% |
| 1879.176 | 274 | 0.7% |
| 1258.3767 | 263 | 0.7% |
| Other values (1287) | 34889 |
| Value | Count | Frequency (%) |
| 1.374 | 15 | < 0.1% |
| 2.748 | 11 | < 0.1% |
| 2.994 | 20 | 0.1% |
| 4.122 | 6 | < 0.1% |
| 4.77 | 26 | 0.1% |
| 5.1865 | 72 | |
| 5.394 | 57 | |
| 5.496 | 9 | < 0.1% |
| 5.7 | 13 | < 0.1% |
| 5.988 | 22 | 0.1% |
| Value | Count | Frequency (%) |
| 27893.619 | 1 | |
| 27055.76042 | 1 | |
| 26159.20808 | 1 | |
| 24938.47611 | 1 | |
| 23190.65179 | 2 | |
| 23020.13179 | 2 | |
| 22963.365 | 1 | |
| 22422.17835 | 1 | |
| 21176.50178 | 1 | |
| 21101.78748 | 2 |
Country_y
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 303.3 KiB |
| US |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 77604 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
Common Values
| Value | Count | Frequency (%) |
| US | 38802 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| us | 38802 |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 38802 | |
| S | 38802 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 77604 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 38802 | |
| S | 38802 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 77604 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| U | 38802 | |
| S | 38802 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 77604 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| U | 38802 | |
| S | 38802 |
Territory
Text
| Distinct | 289 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 303.3 KiB |
Length
| Max length | 16 |
|---|---|
| Median length | 14 |
| Mean length | 8.2890573 |
| Min length | 4 |
Characters and Unicode
| Total characters | 321632 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Casper |
|---|---|
| 2nd row | Seattle |
| 3rd row | Puyallup |
| 4th row | Casper |
| 5th row | Seattle |
| Value | Count | Frequency (%) |
| city | 1620 | 3.3% |
| seattle | 817 | 1.7% |
| san | 817 | 1.7% |
| saint | 749 | 1.5% |
| new | 721 | 1.5% |
| union | 721 | 1.5% |
| garland | 712 | 1.5% |
| miami | 703 | 1.4% |
| lake | 682 | 1.4% |
| houston | 677 | 1.4% |
| Other values (308) | 40516 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 29449 | 9.2% |
| a | 27855 | 8.7% |
| o | 25300 | 7.9% |
| n | 24718 | 7.7% |
| l | 23146 | 7.2% |
| i | 20720 | 6.4% |
| t | 18884 | 5.9% |
| r | 17232 | 5.4% |
| s | 14907 | 4.6% |
| 9933 | 3.1% | |
| Other values (41) | 109488 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 262356 | |
| Uppercase Letter | 49039 | 15.2% |
| Space Separator | 9933 | 3.1% |
| Dash Punctuation | 304 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 29449 | |
| a | 27855 | |
| o | 25300 | |
| n | 24718 | |
| l | 23146 | |
| i | 20720 | |
| t | 18884 | 7.2% |
| r | 17232 | 6.6% |
| s | 14907 | 5.7% |
| d | 8839 | 3.4% |
| Other values (15) | 51306 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 6689 | |
| S | 6383 | |
| M | 4866 | 9.9% |
| L | 4167 | 8.5% |
| N | 2955 | 6.0% |
| G | 2358 | 4.8% |
| H | 2345 | 4.8% |
| B | 2311 | 4.7% |
| P | 2199 | 4.5% |
| R | 1638 | 3.3% |
| Other values (14) | 13128 |
Space Separator
| Value | Count | Frequency (%) |
| 9933 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 304 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 311395 | |
| Common | 10237 | 3.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 29449 | 9.5% |
| a | 27855 | 8.9% |
| o | 25300 | 8.1% |
| n | 24718 | 7.9% |
| l | 23146 | 7.4% |
| i | 20720 | 6.7% |
| t | 18884 | 6.1% |
| r | 17232 | 5.5% |
| s | 14907 | 4.8% |
| d | 8839 | 2.8% |
| Other values (39) | 100345 |
Common
| Value | Count | Frequency (%) |
| 9933 | ||
| - | 304 | 3.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 321632 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 29449 | 9.2% |
| a | 27855 | 8.7% |
| o | 25300 | 7.9% |
| n | 24718 | 7.7% |
| l | 23146 | 7.2% |
| i | 20720 | 6.4% |
| t | 18884 | 5.9% |
| r | 17232 | 5.4% |
| s | 14907 | 4.6% |
| 9933 | 3.1% | |
| Other values (41) | 109488 |
State_duplicated_0
Categorical
HIGH CORRELATION 
| Distinct | 35 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 303.3 KiB |
| California | |
|---|---|
| Texas | |
| Washington | |
| Florida | 1851 |
| Colorado | 1673 |
| Other values (30) |
Length
| Max length | 14 |
|---|---|
| Median length | 12 |
| Mean length | 8.2943663 |
| Min length | 4 |
Characters and Unicode
| Total characters | 321838 |
|---|---|
| Distinct characters | 43 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Wyoming |
|---|---|
| 2nd row | Washington |
| 3rd row | Washington |
| 4th row | Wyoming |
| 5th row | Washington |
Common Values
| Value | Count | Frequency (%) |
| California | 6920 | |
| Texas | 4785 | 12.3% |
| Washington | 4579 | 11.8% |
| Florida | 1851 | 4.8% |
| Colorado | 1673 | 4.3% |
| Michigan | 1384 | 3.6% |
| New York | 1370 | 3.5% |
| Missouri | 1284 | 3.3% |
| New Hampshire | 1264 | 3.3% |
| Tennessee | 1212 | 3.1% |
| Other values (25) | 12480 |
Length
| Value | Count | Frequency (%) |
| california | 6920 | |
| texas | 4785 | 11.1% |
| washington | 4579 | 10.6% |
| new | 3157 | 7.3% |
| florida | 1851 | 4.3% |
| colorado | 1673 | 3.9% |
| michigan | 1384 | 3.2% |
| york | 1370 | 3.2% |
| missouri | 1284 | 3.0% |
| hampshire | 1264 | 2.9% |
| Other values (28) | 14785 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 39582 | |
| i | 38715 | |
| o | 30528 | 9.5% |
| n | 30517 | 9.5% |
| r | 19724 | 6.1% |
| e | 19388 | 6.0% |
| s | 19269 | 6.0% |
| l | 12399 | 3.9% |
| C | 10462 | 3.3% |
| h | 10358 | 3.2% |
| Other values (33) | 90896 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 274536 | |
| Uppercase Letter | 43052 | 13.4% |
| Space Separator | 4250 | 1.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 39582 | |
| i | 38715 | |
| o | 30528 | |
| n | 30517 | |
| r | 19724 | |
| e | 19388 | |
| s | 19269 | |
| l | 12399 | 4.5% |
| h | 10358 | 3.8% |
| t | 9536 | 3.5% |
| Other values (14) | 44520 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 10462 | |
| T | 5997 | |
| W | 5336 | |
| N | 4619 | |
| M | 4598 | |
| O | 1947 | 4.5% |
| F | 1851 | 4.3% |
| I | 1563 | 3.6% |
| Y | 1370 | 3.2% |
| H | 1264 | 2.9% |
| Other values (8) | 4045 | 9.4% |
Space Separator
| Value | Count | Frequency (%) |
| 4250 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 317588 | |
| Common | 4250 | 1.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 39582 | |
| i | 38715 | |
| o | 30528 | 9.6% |
| n | 30517 | 9.6% |
| r | 19724 | 6.2% |
| e | 19388 | 6.1% |
| s | 19269 | 6.1% |
| l | 12399 | 3.9% |
| C | 10462 | 3.3% |
| h | 10358 | 3.3% |
| Other values (32) | 86646 |
Common
| Value | Count | Frequency (%) |
| 4250 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 321838 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 39582 | |
| i | 38715 | |
| o | 30528 | 9.5% |
| n | 30517 | 9.5% |
| r | 19724 | 6.1% |
| e | 19388 | 6.0% |
| s | 19269 | 6.0% |
| l | 12399 | 3.9% |
| C | 10462 | 3.3% |
| h | 10358 | 3.2% |
| Other values (33) | 90896 |
StateCD
Categorical
HIGH CORRELATION 
| Distinct | 35 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 303.3 KiB |
| CA | |
|---|---|
| TX | |
| WA | |
| FL | 1851 |
| CO | 1673 |
| Other values (30) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 77604 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | WY |
|---|---|
| 2nd row | WA |
| 3rd row | WA |
| 4th row | WY |
| 5th row | WA |
Common Values
| Value | Count | Frequency (%) |
| CA | 6920 | |
| TX | 4785 | 12.3% |
| WA | 4579 | 11.8% |
| FL | 1851 | 4.8% |
| CO | 1673 | 4.3% |
| MI | 1384 | 3.6% |
| NY | 1370 | 3.5% |
| MO | 1284 | 3.3% |
| NH | 1264 | 3.3% |
| TN | 1212 | 3.1% |
| Other values (25) | 12480 |
Length
| Value | Count | Frequency (%) |
| ca | 6920 | |
| tx | 4785 | 12.3% |
| wa | 4579 | 11.8% |
| fl | 1851 | 4.8% |
| co | 1673 | 4.3% |
| mi | 1384 | 3.6% |
| ny | 1370 | 3.5% |
| mo | 1284 | 3.3% |
| nh | 1264 | 3.3% |
| tn | 1212 | 3.1% |
| Other values (25) | 12480 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 14147 | |
| C | 10462 | |
| T | 7863 | |
| N | 7241 | |
| W | 5336 | 6.9% |
| O | 4904 | 6.3% |
| X | 4785 | 6.2% |
| M | 4598 | 5.9% |
| I | 3319 | 4.3% |
| L | 2362 | 3.0% |
| Other values (12) | 12587 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 77604 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 14147 | |
| C | 10462 | |
| T | 7863 | |
| N | 7241 | |
| W | 5336 | 6.9% |
| O | 4904 | 6.3% |
| X | 4785 | 6.2% |
| M | 4598 | 5.9% |
| I | 3319 | 4.3% |
| L | 2362 | 3.0% |
| Other values (12) | 12587 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 77604 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 14147 | |
| C | 10462 | |
| T | 7863 | |
| N | 7241 | |
| W | 5336 | 6.9% |
| O | 4904 | 6.3% |
| X | 4785 | 6.2% |
| M | 4598 | 5.9% |
| I | 3319 | 4.3% |
| L | 2362 | 3.0% |
| Other values (12) | 12587 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 77604 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 14147 | |
| C | 10462 | |
| T | 7863 | |
| N | 7241 | |
| W | 5336 | 6.9% |
| O | 4904 | 6.3% |
| X | 4785 | 6.2% |
| M | 4598 | 5.9% |
| I | 3319 | 4.3% |
| L | 2362 | 3.0% |
| Other values (12) | 12587 |
City_y
Text
| Distinct | 189 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 303.3 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 19 |
| Mean length | 7.5818772 |
| Min length | 3 |
Characters and Unicode
| Total characters | 294192 |
|---|---|
| Distinct characters | 54 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Natrona |
|---|---|
| 2nd row | King |
| 3rd row | Pierce |
| 4th row | Natrona |
| 5th row | King |
| Value | Count | Frequency (%) |
| los | 2441 | 5.3% |
| angeles | 2441 | 5.3% |
| king | 2212 | 4.8% |
| dallas | 2081 | 4.5% |
| san | 1334 | 2.9% |
| maricopa | 1048 | 2.3% |
| harris | 938 | 2.0% |
| orange | 888 | 1.9% |
| st | 845 | 1.8% |
| alameda | 765 | 1.6% |
| Other values (195) | 31373 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 35731 | 12.1% |
| e | 24277 | 8.3% |
| n | 20583 | 7.0% |
| o | 19757 | 6.7% |
| i | 18892 | 6.4% |
| s | 17265 | 5.9% |
| l | 17008 | 5.8% |
| r | 16918 | 5.8% |
| t | 9878 | 3.4% |
| g | 9283 | 3.2% |
| Other values (44) | 104600 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 237133 | |
| Uppercase Letter | 46491 | 15.8% |
| Space Separator | 7564 | 2.6% |
| Other Punctuation | 845 | 0.3% |
| Open Punctuation | 728 | 0.2% |
| Close Punctuation | 728 | 0.2% |
| Dash Punctuation | 703 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 35731 | |
| e | 24277 | |
| n | 20583 | |
| o | 19757 | |
| i | 18892 | 8.0% |
| s | 17265 | 7.3% |
| l | 17008 | 7.2% |
| r | 16918 | 7.1% |
| t | 9878 | 4.2% |
| g | 9283 | 3.9% |
| Other values (16) | 47541 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 5632 | |
| L | 5130 | |
| D | 4953 | |
| A | 4029 | |
| M | 3227 | 6.9% |
| H | 3109 | 6.7% |
| C | 2949 | 6.3% |
| K | 2713 | 5.8% |
| B | 2671 | 5.7% |
| W | 2329 | 5.0% |
| Other values (13) | 9749 |
Space Separator
| Value | Count | Frequency (%) |
| 7564 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 845 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 728 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 728 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 703 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 283624 | |
| Common | 10568 | 3.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 35731 | 12.6% |
| e | 24277 | 8.6% |
| n | 20583 | 7.3% |
| o | 19757 | 7.0% |
| i | 18892 | 6.7% |
| s | 17265 | 6.1% |
| l | 17008 | 6.0% |
| r | 16918 | 6.0% |
| t | 9878 | 3.5% |
| g | 9283 | 3.3% |
| Other values (39) | 94032 |
Common
| Value | Count | Frequency (%) |
| 7564 | ||
| . | 845 | 8.0% |
| ( | 728 | 6.9% |
| ) | 728 | 6.9% |
| - | 703 | 6.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 293760 | |
| None | 432 | 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 35731 | 12.2% |
| e | 24277 | 8.3% |
| n | 20583 | 7.0% |
| o | 19757 | 6.7% |
| i | 18892 | 6.4% |
| s | 17265 | 5.9% |
| l | 17008 | 5.8% |
| r | 16918 | 5.8% |
| t | 9878 | 3.4% |
| g | 9283 | 3.2% |
| Other values (43) | 104168 |
None
| Value | Count | Frequency (%) |
| ñ | 432 |
| Employee | ListPrice | NetSales | OrderQuantity | Sales | SaleswithStandard | StandardCost | State | StateCD | State_duplicated_0 | UnitPrice | productcategory | productsubcategory | saleterritory | zip | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Employee | 1.000 | 0.025 | -0.029 | -0.058 | 0.001 | 0.003 | 0.024 | 0.636 | 0.636 | 0.636 | 0.025 | 0.031 | 0.087 | 0.698 | -0.068 |
| ListPrice | 0.025 | 1.000 | -0.306 | -0.173 | 0.911 | 0.916 | 0.990 | 0.095 | 0.095 | 0.095 | 0.998 | 0.532 | 0.465 | 0.049 | 0.020 |
| NetSales | -0.029 | -0.306 | 1.000 | 0.076 | -0.284 | -0.357 | -0.377 | 0.025 | 0.025 | 0.025 | -0.298 | 0.148 | 0.106 | 0.014 | 0.014 |
| OrderQuantity | -0.058 | -0.173 | 0.076 | 1.000 | 0.202 | 0.183 | -0.176 | 0.049 | 0.049 | 0.049 | -0.176 | 0.175 | 0.114 | 0.022 | 0.045 |
| Sales | 0.001 | 0.911 | -0.284 | 0.202 | 1.000 | 0.992 | 0.904 | 0.039 | 0.039 | 0.039 | 0.912 | 0.253 | 0.159 | 0.029 | 0.032 |
| SaleswithStandard | 0.003 | 0.916 | -0.357 | 0.183 | 0.992 | 1.000 | 0.920 | 0.029 | 0.029 | 0.029 | 0.913 | 0.211 | 0.128 | 0.021 | 0.031 |
| StandardCost | 0.024 | 0.990 | -0.377 | -0.176 | 0.904 | 0.920 | 1.000 | 0.102 | 0.102 | 0.102 | 0.989 | 0.539 | 0.472 | 0.063 | 0.016 |
| State | 0.636 | 0.095 | 0.025 | 0.049 | 0.039 | 0.029 | 0.102 | 1.000 | 1.000 | 1.000 | 0.017 | 0.110 | 0.092 | 1.000 | 0.066 |
| StateCD | 0.636 | 0.095 | 0.025 | 0.049 | 0.039 | 0.029 | 0.102 | 1.000 | 1.000 | 1.000 | 0.016 | 0.110 | 0.092 | 0.999 | 0.073 |
| State_duplicated_0 | 0.636 | 0.095 | 0.025 | 0.049 | 0.039 | 0.029 | 0.102 | 1.000 | 1.000 | 1.000 | 0.017 | 0.110 | 0.092 | 0.999 | 0.066 |
| UnitPrice | 0.025 | 0.998 | -0.298 | -0.176 | 0.912 | 0.913 | 0.989 | 0.017 | 0.016 | 0.017 | 1.000 | 0.526 | 0.453 | 0.046 | 0.018 |
| productcategory | 0.031 | 0.532 | 0.148 | 0.175 | 0.253 | 0.211 | 0.539 | 0.110 | 0.110 | 0.110 | 0.526 | 1.000 | 1.000 | 0.026 | 0.006 |
| productsubcategory | 0.087 | 0.465 | 0.106 | 0.114 | 0.159 | 0.128 | 0.472 | 0.092 | 0.092 | 0.092 | 0.453 | 1.000 | 1.000 | 0.110 | 0.011 |
| saleterritory | 0.698 | 0.049 | 0.014 | 0.022 | 0.029 | 0.021 | 0.063 | 1.000 | 0.999 | 0.999 | 0.046 | 0.026 | 0.110 | 1.000 | 0.330 |
| zip | -0.068 | 0.020 | 0.014 | 0.045 | 0.032 | 0.031 | 0.016 | 0.066 | 0.073 | 0.066 | 0.018 | 0.006 | 0.011 | 0.330 | 1.000 |
| productcategory | productsubcategory | saleterritory | zip | State | Customer | Employee | OrderCount | OrderDate | StandardCost | UnitPrice | ListPrice | SaleswithStandard | NetSales | OrderQuantity | Sales | Country_y | Territory | State_duplicated_0 | StateCD | City_y | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Clothing | Caps | Northwest | 82601 | Wyoming | François Ferrier | David Campbell | 1 | 5/31/2011 0:00 | 6.9223 | 5.1865 | 8.6442 | 20.7669 | -5.2074 | 3 | 15.5595 | US | Casper | Wyoming | WY | Natrona |
| 1 | Clothing | Caps | Northwest | 98104 | Washington | Richard Bready | David Campbell | 1 | 5/31/2011 0:00 | 6.9223 | 5.1865 | 8.6442 | 13.8446 | -3.4716 | 2 | 10.3730 | US | Seattle | Washington | WA | King |
| 2 | Components | Mountain Frames | Northwest | 98371 | Washington | Carolyn Farino | David Campbell | 1 | 5/31/2011 0:00 | 739.0410 | 714.7043 | 1191.1739 | 739.0410 | -24.3367 | 1 | 714.7043 | US | Puyallup | Washington | WA | Pierce |
| 3 | Clothing | Jerseys | Northwest | 82601 | Wyoming | François Ferrier | David Campbell | 1 | 5/31/2011 0:00 | 38.4923 | 28.8404 | 48.0673 | 76.9846 | -19.3038 | 2 | 57.6808 | US | Casper | Wyoming | WY | Natrona |
| 4 | Clothing | Jerseys | Northwest | 98104 | Washington | Richard Bready | David Campbell | 1 | 5/31/2011 0:00 | 38.4923 | 28.8404 | 48.0673 | 76.9846 | -19.3038 | 2 | 57.6808 | US | Seattle | Washington | WA | King |
| 5 | Clothing | Jerseys | Northwest | 98366 | Washington | Peggy Justice | David Campbell | 1 | 5/31/2011 0:00 | 38.4923 | 28.8404 | 48.0673 | 76.9846 | -19.3038 | 2 | 57.6808 | US | Port Orchard | Washington | WA | Kitsap |
| 6 | Clothing | Jerseys | Northwest | 98366 | Washington | Peggy Justice | David Campbell | 1 | 5/31/2011 0:00 | 38.4923 | 28.8404 | 48.0673 | 38.4923 | -9.6519 | 1 | 28.8404 | US | Port Orchard | Washington | WA | Kitsap |
| 7 | Components | Road Frames | Northwest | 98366 | Washington | Peggy Justice | David Campbell | 1 | 5/31/2011 0:00 | 352.1394 | 356.8980 | 594.8300 | 704.2788 | 9.5172 | 2 | 713.7960 | US | Port Orchard | Washington | WA | Kitsap |
| 8 | Clothing | Socks | Northwest | 82601 | Wyoming | François Ferrier | David Campbell | 1 | 5/31/2011 0:00 | 3.3963 | 5.7000 | 9.5000 | 20.3778 | 13.8222 | 6 | 34.2000 | US | Casper | Wyoming | WY | Natrona |
| 9 | Clothing | Socks | Northwest | 98104 | Washington | Richard Bready | David Campbell | 1 | 5/31/2011 0:00 | 3.3963 | 5.7000 | 9.5000 | 20.3778 | 13.8222 | 6 | 34.2000 | US | Seattle | Washington | WA | King |
| productcategory | productsubcategory | saleterritory | zip | State | Customer | Employee | OrderCount | OrderDate | StandardCost | UnitPrice | ListPrice | SaleswithStandard | NetSales | OrderQuantity | Sales | Country_y | Territory | State_duplicated_0 | StateCD | City_y | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 38792 | Bikes | Touring Bikes | Southeast | 34205 | Florida | Chris Bidelman | Tsvi Reiter | 1 | 5/1/2014 0:00 | 461.4448 | 445.4100 | 742.35 | 922.8896 | -32.069600 | 2 | 890.820000 | US | Bradenton | Florida | FL | Manatee |
| 38793 | Bikes | Touring Bikes | Southeast | 33602 | Florida | Liam Friedland | Tsvi Reiter | 1 | 5/1/2014 0:00 | 461.4448 | 445.4100 | 742.35 | 461.4448 | -16.034800 | 1 | 445.410000 | US | Tampa | Florida | FL | Hillsborough |
| 38794 | Bikes | Touring Bikes | Southeast | 27603 | North Carolina | Reinout Hillmann | Tsvi Reiter | 1 | 5/1/2014 0:00 | 461.4448 | 445.4100 | 742.35 | 461.4448 | -16.034800 | 1 | 445.410000 | US | Raleigh | North Carolina | NC | Wake |
| 38795 | Accessories | Bottles and Cages | Southeast | 34205 | Florida | Chris Bidelman | Tsvi Reiter | 1 | 5/1/2014 0:00 | 1.8663 | 2.8942 | 4.99 | 26.1282 | 13.580224 | 14 | 39.708424 | US | Bradenton | Florida | FL | Manatee |
| 38796 | Clothing | Shorts | Southeast | 37801 | Tennessee | Elizabeth Catalano | Tsvi Reiter | 1 | 5/1/2014 0:00 | 26.1763 | 41.9940 | 69.99 | 78.5289 | 47.453100 | 3 | 125.982000 | US | Maryville | Tennessee | TN | Blount |
| 38797 | Clothing | Shorts | Southeast | 30030 | Georgia | Pamela Cox | Tsvi Reiter | 1 | 5/1/2014 0:00 | 26.1763 | 41.9940 | 69.99 | 209.4104 | 126.541600 | 8 | 335.952000 | US | Decatur | Georgia | GA | DeKalb |
| 38798 | Clothing | Shorts | Southeast | 33127 | Florida | Stephanie Conroy | Tsvi Reiter | 1 | 5/1/2014 0:00 | 26.1763 | 41.9940 | 69.99 | 157.0578 | 94.906200 | 6 | 251.964000 | US | Miami | Florida | FL | Miami-Dade |
| 38799 | Clothing | Shorts | Southeast | 30030 | Georgia | Pamela Cox | Tsvi Reiter | 1 | 5/1/2014 0:00 | 26.1763 | 41.9940 | 69.99 | 78.5289 | 47.453100 | 3 | 125.982000 | US | Decatur | Georgia | GA | DeKalb |
| 38800 | Clothing | Shorts | Southeast | 30030 | Georgia | Pamela Cox | Tsvi Reiter | 1 | 5/1/2014 0:00 | 26.1763 | 41.9940 | 69.99 | 130.8815 | 79.088500 | 5 | 209.970000 | US | Decatur | Georgia | GA | DeKalb |
| 38801 | Clothing | Shorts | Southeast | 33127 | Florida | Stephanie Conroy | Tsvi Reiter | 1 | 5/1/2014 0:00 | 26.1763 | 41.9940 | 69.99 | 78.5289 | 47.453100 | 3 | 125.982000 | US | Miami | Florida | FL | Miami-Dade |
Most frequently occurring
| productcategory | productsubcategory | saleterritory | zip | State | Customer | Employee | OrderCount | OrderDate | StandardCost | UnitPrice | ListPrice | SaleswithStandard | NetSales | OrderQuantity | Sales | Country_y | Territory | State_duplicated_0 | StateCD | City_y | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1175 | Bikes | Road Bikes | Central | 55056 | Minnesota | Kim Abercrombie | Jillian Carson | 1 | 10/31/2011 0:00 | 486.7066 | 419.4589 | 699.0982 | 1460.1198 | -201.7431 | 3 | 1258.3767 | US | North Branch | Minnesota | MN | Chisago | 8 |
| 1755 | Bikes | Road Bikes | Northwest | 97005 | Oregon | Joy Koski | Pamela Ansman-Wolfe | 1 | 10/31/2011 0:00 | 486.7066 | 419.4589 | 699.0982 | 1460.1198 | -201.7431 | 3 | 1258.3767 | US | Beaverton | Oregon | OR | Washington | 8 |
| 1760 | Bikes | Road Bikes | Northwest | 97005 | Oregon | Joy Koski | Pamela Ansman-Wolfe | 1 | 4/30/2012 0:00 | 486.7066 | 419.4589 | 699.0982 | 973.4132 | -134.4954 | 2 | 838.9178 | US | Beaverton | Oregon | OR | Washington | 8 |
| 2676 | Bikes | Road Bikes | Southwest | 91016 | California | Jean Jordan | Shu Ito | 1 | 8/31/2011 0:00 | 486.7066 | 419.4589 | 699.0982 | 486.7066 | -67.2477 | 1 | 419.4589 | US | Monrovia | California | CA | Los Angeles | 8 |
| 1575 | Bikes | Road Bikes | Northeast | 6512 | Connecticut | Sara Breer | Michael Blythe | 1 | 8/1/2011 0:00 | 486.7066 | 419.4589 | 699.0982 | 486.7066 | -67.2477 | 1 | 419.4589 | US | New Haven | Connecticut | CT | New Haven | 7 |
| 1805 | Bikes | Road Bikes | Northwest | 98104 | Washington | Orlando Gee | Pamela Ansman-Wolfe | 1 | 3/30/2012 0:00 | 486.7066 | 419.4589 | 699.0982 | 486.7066 | -67.2477 | 1 | 419.4589 | US | Seattle | Washington | WA | King | 7 |
| 1993 | Bikes | Road Bikes | Southeast | 27104 | North Carolina | Brannon Jones | Tsvi Reiter | 1 | 3/30/2012 0:00 | 486.7066 | 419.4589 | 699.0982 | 486.7066 | -67.2477 | 1 | 419.4589 | US | Winston-Salem | North Carolina | NC | Forsyth | 7 |
| 2801 | Bikes | Road Bikes | Southwest | 92867 | California | Jessie Valerio | Linda Mitchell | 1 | 3/30/2012 0:00 | 486.7066 | 419.4589 | 699.0982 | 486.7066 | -67.2477 | 1 | 419.4589 | US | Orange | California | CA | Orange | 7 |
| 2932 | Bikes | Road Bikes | Southwest | 95354 | California | Frances Adams | Shu Ito | 1 | 8/31/2011 0:00 | 486.7066 | 419.4589 | 699.0982 | 486.7066 | -67.2477 | 1 | 419.4589 | US | Modesto | California | CA | Stanislaus | 7 |
| 1116 | Bikes | Road Bikes | Central | 53182 | Wisconsin | Lee Chapla | Jillian Carson | 1 | 10/30/2012 0:00 | 486.7066 | 469.7940 | 782.9900 | 973.4132 | -33.8252 | 2 | 939.5880 | US | Union Grove | Wisconsin | WI | Racine | 6 |